use "C:\Users\jssrc\OneDrive - Old Dominion University\SpuriousCorrelation\Results\Data for Table 1 and Figure 2\SpatiallyCorrelatedCrosssectional.dta" 

summarize maxcorrelationnum
// to calculate 95th percentiles and confidence intervals. 
generate maxwithmissing = maxcorrelationnum
replace maxwithmissing = 0 if iscorrelation == 0
centile maxwithmissing , centile(95)

clear
use "C:\Users\jssrc\OneDrive - Old Dominion University\SpuriousCorrelation\Results\Data for Table 1 and Figure 2\Gammacrosssectionalupdated.dta"
summarize maxcorrelationnum
// to calculate 95th percentiles and confidence intervals. 
generate maxwithmissing = maxcorrelationnum
replace maxwithmissing = 0 if iscorrelation == 0
centile maxwithmissing , centile(95)

clear
use "C:\Users\jssrc\OneDrive - Old Dominion University\SpuriousCorrelation\Results\Data for Table 1 and Figure 2\normalresults.dta"
summarize maxcorrellation
// to calculate 95th percentiles and confidence intervals. 
generate maxwithmissing = maxcorrellation
replace maxwithmissing = 0 if iscorrelation == 0
centile maxwithmissing , centile(95)

clear
import excel "C:\Users\jssrc\OneDrive - Old Dominion University\SpuriousCorrelation\Results\Data for Table 1 and Figure 2\RESULTSunifCross-.xlsx", sheet("additionalobservations") firstrow
destring MaxCorrellation, generate(maxcorrelationnum) force
summarize maxcorrelationnum
// to calculate 95th percentiles and confidence intervals. 
generate maxwithmissing = maxcorrelationnum
replace maxwithmissing = 0 if Iscorrelation == 0
centile maxwithmissing , centile(95)

clear
use "C:\Users\jssrc\OneDrive - Old Dominion University\SpuriousCorrelation\Results\Data for Table 1 and Figure 2\Meanrevertingnormal.dta"
summarize maxcorrelationnum
// to calculate 95th percentiles and confidence intervals. 
generate maxwithmissing = maxcorrelationnum
replace maxwithmissing = 0 if iscorrelation == 0
centile maxwithmissing , centile(95)

clear
import excel "C:\Users\jssrc\OneDrive - Old Dominion University\SpuriousCorrelation\Results\Data for Table 1 and Figure 2\RandomWalkResults.xlsx", sheet("SpatialCorrelatedResults") firstrow
destring MaxCorrellation, generate(maxcorrelationnum) force
summarize maxcorrelationnum
// to calculate 95th percentiles and confidence intervals. 
generate maxwithmissing = maxcorrelationnum
replace maxwithmissing = 0 if Iscorrelation == 0
centile maxwithmissing , centile(95)



